home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Magnum One
/
Magnum One (Mid-American Digital) (Disc Manufacturing).iso
/
d13
/
qptech.arc
/
TI194.ASC
< prev
next >
Wrap
Text File
|
1991-04-25
|
1KB
|
67 lines
PRODUCT : QUATTRO PRO NUMBER : 194
VERSION : ALL
OS : MS/PC DOS
DATE : April 5, 1991 PAGE : 1/1
TITLE : FILE FIND MACRO
This is a macro for checking whether a spreadsheet is currently
opened or closed in Quattro Pro. The macro beeps when a
spreadsheet named FILENAME is currently open, or executes a macro
named FILE NOT OPEN when it is not.
A11: 'FINDFILE
B11: '{choose}
B12: '{edit}
B13: 'FILENAME
B14: '{CR}
B15: '{if
@iserr(@find("FILENAME",@curvalue("file","save"),0))}{file not
open}
B16: '{beep}
In your spreadsheet, the macro will appear as follows:
FILEFIND {choose}
{edit}
filename
{CR}
{if
@iserr(@find("FILENAME",@curvalue("file","save"),0))}{file not
open}
{beep}
To test for an open file, the FILEFIND macro should be in your
current spreadsheet. Change the cell containing the label
filename to the name of the file to check. To execute this
macro, select / <T>ools <M>acro <E>xecute FILEFIND and press
<Enter>.